USe DI_Local
Go

select DISTINCT DF_NAME, NAME, DATATYPE_NAME from AL_COLUMN A
INNER JOIN AL_DATATYPE_NAMES B ON
A.DATATYPE = B.DATATYPE_ID
INNER JOIN AL_COLMAP_TEXT C ON
A.NAME = C.TRG_COL_NAME
WHERE NAME LIKE '%DATEID' AND DATATYPE_NAME = 'DOUBLE'



/**

